DatePart example

DatePart('m',[OrderDate])
(where [OrderDate] is the name of the field).

[OrderDate]=28-Mar-1996

Result = 3 (month of year)